package com.music.service.composer.constants;

public class ComposerSQLQueries {
	public final static String ADD_NEW_COMPOSER =
		"insert into composers(created_member_id,composer_name,state,creation_date,last_update_date)" +
		"values (?,?,?,sysdate,sysdate)";
	
	public final static String DELETE_COMPOSER =
		"update albums set state = ? where composer_id = ? && created_member_id = ? && state != ?";
	
	public final static String EDIT_COMPOSER_NAME =
		"udpate composers set composer_name=? where composer_id=? && created_member_id=? && state = ?";
}
